FO_Hub_Definition

This table is used to create a Hub definition.

 

Field Type Notes

Hub_Def_ID

int

ID field, a counter. Unique

HubCode

varchar(50)

Code for HUB

HubName

varchar(80)

Name or description of HUB.

Required field.

HubAdd1

varchar(80)

First address line.

Informational

HubAdd2

varchar(80)

Second address line.

Informational

HubCity

varchar(50)

City.

Informational

HubState

varchar(50)

State.

Informational

HubCounty

varchar(50)

County.

Informational

HubCountry

varchar(50)

Country.

Informational

HubTel

varchar(50)

Phone number.

Informational

CreateDate

datetime

Date record was created.

Informational

EditDate

datetime

Date record was last edited.

Informational

CreateUser

varchar(50)

User who created record.

Informational

EditUser

varchar(50)

User who last edited record.

Informational

ZipCode

varchar(50)

Zip code.

Informational